OFFER_RATE and INTERVIEW_RATE OVER YEAR
1) How to create
- (1) In Visualizations choose Line Chart
- (2) Drag and drop Month ( From Fact_Submission_Interview_Offer ---> SubmissionDate ---> Date Hierachy --->
Month) to Axis
- (3) Drag and drop INTERVIEW RATE and OFFER RATE to Values
- (4) In Filter Pane ---> Click to SubmissionDate - Month ---> Check Select all and then uncheck Blank
2) Change the visualization
- (1) Click to Format
-(2) In General change the Width to" 565" and the Height to "250"
- (3) Legend ---> Style ---> Choose Line and markers
- (4) Turn the Data labels on
- (5) Click to Shape ---> turn the Show marker on
- (6) Title
6.1 Change the title name to " INTERVIEW RATE AND OFFER RATE OVER MONTH"
6.2 Change the Font color to "White" and Background color to "Blue"
6.3 Choose the Middle Alignment
6.4 Text size 14
- (7) Turn the Border on ---> Change the color to "Blue"
OFFER_RATE and INTERVIEW_RATE by JOB _TAG
- (1) In Visualizations choose Line and clustered column chart
- (2) Drag and drop Jobtag_New column (from Dim_JRP_Tags table) to Shared Axis
- (3) Drag and drop OFFER RATE to Column values
- (4) Drag and drop INTERVIEW RATE to Line values
- (5) Click to Shape ---> turn Show marker on
6.1 Change the title name to " INTERVIEW RATE AND OFFER RATE BY JOBTAG"
JOB BY STATE
1) Enable Shape Map
- (1) Click to File
- (2) Click Options and setting ---> Choose Options
- (3) Click Preview features
- (4) Check Shape map visual
- (5) Click OK
-(6) Restart the package
2) Create the Map
- (1) In Visualizations choose Shape Map
- (2) Drag and drop State column ( Dim_JRP_Clients table ) to Location
- (3) Drag and Drop INTERVIEW_RATE to Color saturation
3) Change the visualization
- (2) Data colors ---> Choose Light Blue color for minimum and Dark Blue color for Maximum ---> In Minimum
box type 0, In Maximum box type 0.15
- (3) Title
3.1 Change the title name to " INTERVIEW RATE BY STATE"
3.2 Change the Font color to "White" and Background color to "Blue"
3.3 Choose the Middle Alignment
3.4 Text size 14
- (4) In General change the Width to" 565" and the Height to "250"
- (5) Turn the Border on ---> Change the color to "Blue"
Create visual shows the latest time data refresh
- Choose table from Visualization
- Drag and Drop column Refresh from Fact_JobReferral table to Values
- Drag and Drop the table to change the size and move it to the right corner of the Dashboard
visualization option in power bi clicks below to know more.
https://www.tutorialspoint.com/power_bi/power_bi_visualization_options.htm